<?php
$con=mysql_connect("localhost:3307","root","123456")
or die("数据库服务器连接失败！<br>");
//**********found**********
mysql_select_db("nrce-07",$con) or die( "数据库选择失败！<br>");
//**********found**********
//mysql_query("set names 'gbk'");
mysql_query("set names 'gb2312'");
//**********found**********
$sql="UPDATE tb_commodity SET price=3888";
//**********found**********
$sql=$sql." WHERE cname='电冰箱' AND origin='武汉'";
//**********found**********
if (mysql_query($sql,$con))
    echo "商品价格修改成功！<br>";
else
    echo "商品价格修改失败！<br>";
?>

